﻿CREATE TABLE [dbo].[PatientMMCDistanceXfer] (
    [patientDistanceID] BIGINT         IDENTITY (1, 1) NOT NULL,
    [patientID]         BIGINT         NOT NULL,
    [locationID]        INT            NULL,
    [mmcID]             SMALLINT       NOT NULL,
    [distanceInMiles]   NUMERIC (6, 2) NOT NULL
);

